

<?php

class PembayaranSetoranBankController extends Controller {

    /**
     * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
     * using two-column layout. See 'protected/views/layouts/column2.php'.
     */
    public $layout = '//layouts/column1';

    /**
     * @return array action filters
     */
    public function filters() {
        return array(
            'accessControl', // perform access control for CRUD operations
        );
    }

    /**
     * Specifies the access control rules.
     * This method is used by the 'accessControl' filter.
     * @return array access control rules
     */
    public function accessRules() {
        return array(
            array('allow', // allow all users to perform 'index' and 'view' actions
                'actions' => array('index', 'view'),
                'users' => array('*'),
            ),
            array('allow', // allow authenticated user to perform 'create' and 'update' actions
                'actions' => array('create', 'update'),
                'users' => array('@'),
            ),
            array('allow', // allow admin user to perform 'admin' and 'delete' actions
                'actions' => array('admin', 'delete'),
                'users' => array('admin'),
            ),
            array('deny', // deny all users
                'users' => array('*'),
            ),
        );
    }

    /**
     * Displays a particular model.
     * @param integer $id the ID of the model to be displayed
     */
    public function actionView($id, $id2, $id3) {
        $this->render('view', array(
            'model' => $this->loadModel($id, $id2, $id3),
        ));
    }

    /**
     * Creates a new model.
     * If creation is successful, the browser will be redirected to the 'view' page.
     */
    public function actionCreate() {
        $model = new ObjekPajak;
        $modelSetoran = new Setoran;
        $modelWajibPajak = new WajibPajak;
        $modelSk = new Sk;

        $model->unsetAttributes();  // clear any default values
        if (isset($_GET['ObjekPajak']))
            $model->attributes = $_GET['ObjekPajak'];

        $model->unsetAttributes();  // clear any default values
        if (isset($_GET['Sk']))
            $modelSk->attributes = $_GET['Sk'];

        $modelWajibPajak->unsetAttributes();  // clear any default values
        if (isset($_GET['WajibPajak']))
            $modelWajibPajak->attributes = $_GET['WajibPajak'];

        $modelSetoran->unsetAttributes();  // clear any default values
        if (isset($_POST['Setoran'])) {
            $model->attributes = $_POST['Setoran'];
            $transaction = Yii::app()->db->beginTransaction();
            try {


                if ($model->save() && $modelWajibPajak->save() && $modelSetoran->save() && $modelSk->save()) {
                    $transaction->commit();

                    $this->redirect(array('admin'));
                }
            } catch (Exception $e) {
                $transaction->rollback();
                throw new CHttpException(400, $e->getMessage());
            }
        }


$modelSk = Sk::model()->findAll();

        $this->render('create', array(
            'model' => $model,
            'modelWajibPajak' => $modelWajibPajak,
            'modelSetoran' => $modelSetoran,
            'modelSk' => $modelSk,
        ));
    }

    
    public function select(){
        
        $sql='SELECT o.*, k.nama_kel, c.nama_kec, j.jenis_prh FROM objek_pajak o, 
kecamatan c, kelurahan k, jenis_prh j WHERE k.kode_kec = c.kode_kec 
AND o.kode_kel = k.kode_kel AND j.kode_jns = o.kode_jns
ORDER BY o.no_op, o.tahun DESC';

        echo CJSON::encode($sql);        
    }


    public function actionSelect2() {
        $ObjekPajak = $_POST['no_op'];


        $data = RefDati2::model()->find("no_op='" . $ObjekPajak . "'");
        echo CJSON::encode($data);
    }
    
    
    /**
     * Updates a particular model.
     * If update is successful, the browser will be redirected to the 'view' page.
     * @param integer $id the ID of the model to be updated
     */
    public function actionUpdate($id) {
        $model = $this->loadModel($id);

// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);

        if (isset($_POST['ObjekPajak'])) {
            $model->attributes = $_POST['ObjekPajak'];
            if ($model->save())
                $this->redirect(array('view', 'id' => $model->no_op));
        }

        $this->render('update', array(
            'model' => $model,
        ));
    }

    /**
     * Deletes a particular model.
     * If deletion is successful, the browser will be redirected to the 'admin' page.
     * @param integer $id the ID of the model to be deleted
     */
    public function actionDelete($id) {
        if (Yii::app()->request->isPostRequest) {
// we only allow deletion via POST request
            $this->loadModel($id)->delete();

// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
            if (!isset($_GET['ajax']))
                $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
        }
        else
            throw new CHttpException(400, 'Invalid request. Please do not repeat this request again.');
    }

    /**
     * Lists all models.
     */
    public function actionIndex() {
        $dataProvider = new CActiveDataProvider('ObjekPajak');
        $this->render('index', array(
            'dataProvider' => $dataProvider,
        ));
    }

    /**
     * Manages all models.
     */
    public function actionAdmin() {
        $model = new ObjekPajak('search');
        $model->unsetAttributes();  // clear any default values
        if (isset($_GET['ObjekPajak']))
            $model->attributes = $_GET['ObjekPajak'];

        $this->render('admin', array(
            'model' => $model,
        ));
    }

    /**
     * Returns the data model based on the primary key given in the GET variable.
     * If the data model is not found, an HTTP exception will be raised.
     * @param integer the ID of the model to be loaded
     */
    public function loadModel($id) {
        $model = ObjekPajak::model()->findByPk($id);
        if ($model === null)
            throw new CHttpException(404, 'The requested page does not exist.');
        return $model;
    }

    /**
     * Performs the AJAX validation.
     * @param CModel the model to be validated
     */
    protected function performAjaxValidation($model) {
        if (isset($_POST['ajax']) && $_POST['ajax'] === 'objek-pajak-form') {
            echo CActiveForm::validate($model);
            Yii::app()->end();
        }
    }

}
